################################################################################### 
## 
## Hack Title:    Add new field to profile
## Hack Version:  1.2.1
## optional Part: Display new field in topics 1.0
## Author         Acid
## Support:	  http://www.phpbbhacks.com/forums
##
## Description:   If you want to display the new fields in topic view..
##		  If youve added more than one field duplicate the following
##		  steps and change "music" (be aware of the spelling).
##
## Required:      addfield_english.txt
##
## Files to edit: 2
##		  viewtopic.php
##                templates/xxx/viewtopic_body.tpl
##
################################################################################### 
## 
## Installation/Author Notes: 
## First always backup the files that you're going to edit. 
## 
################################################################################### 
##
## Versions:
##
## 1.0   - optional part added
##
################################################################################### 
# 
#-----[ OPEN ]------------------------------------------
#  
# viewtopic.php
# 
#-----[ FIND ]---------------------------------------------------
# 
$sql = "SELECT u.username, u.user_id, u.user_level, u.user_posts, u.user_from, u.user_custom_rank, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.user_avatar_width, u.user_avatar_height, p.*,  pt.post_text, pt.post_subject, pt.bbcode_uid
	FROM " . POSTS_TABLE . " p, " . USERS_TABLE . " u, " . POSTS_TEXT_TABLE . " pt

# 
#-----[ IN-LINE FIND ]---------------------------------------------------
# 
u.user_from

# 
#-----[ IN-LINE ADD ]---------------------------------------------------
# 
, u.user_music

# 
#-----[ FIND ]---------------------------------------------------
# 
	$poster_from = ( $postrow[$i]['user_from'] && $postrow[$i]['user_id'] != ANONYMOUS ) ? $lang['Location'] . ': ' . $postrow[$i]['user_from'] : '';

# 
#-----[ ADD BELOW ]---------------------------------------------------
# 
	$poster_music = ( $postrow[$i]['user_music'] && $postrow[$i]['user_id'] != ANONYMOUS ) ? $lang['Music'] . ': ' . $postrow[$i]['user_music'] : '';

# 
#-----[ FIND ]---------------------------------------------------
# 
		'POSTER_FROM' => $poster_from,

# 
#-----[ ADD BELOW ]---------------------------------------------------
# 
		'POSTER_MUSIC' => $poster_music,



# 
#-----[ OPEN ]------------------------------------------
#  
# templates/xxx/viewtopic_body.tpl
# 
#-----[ FIND ]---------------------------------------------------
# 
{postrow.POSTER_FROM}

# 
#-----[ AFTER ADD ]---------------------------------------------------
# 
<br />{postrow.POSTER_MUSIC}


################################################################################### 
################################################################################### 
###################################################################################